On The other hand the next part I'm having difficulties to complete following the mass copy and paste has operate I want A further code that should update column A accordingly this kind of which the Occupation num from sheet 2 will fill in to every in between jobs 2 waiting for link from Social Network Posts (2)